SUPPORT / SAMPLES & SAS NOTES
Problem Note 44295: Expanding a SAS® Financial Management table that contains large nested dimensions on the rows might result in red cells and out of memory error
 |  |  |  |  |
If you expand a dimension on a SAS Financial Management Read-Only (OLAP) table that contains multiple large nested dimensions, you might encounter red cells in the table. You might also find an error similar to the following is written to the AMO log:
executeCubeQuery failed: {0}.
System.OutOfMemoryException: Exception of type 'System.OutOfMemoryException' was thrown.
at Com.Sas.Ses.OfficeIntegration.Model.BaseQuery.uncompress(QueryResult ors)
at Com.Sas.Ses.OfficeIntegration.Model.BaseQuery.performQuery
(ServerProviderInterface serverProvider, Int32 vcid, SingleDimAxis[] SDAs, String& diagnosticsString,
String& diagnosticsODCSQueryHistoryString, OverrideProviderInterface opi,
Boolean returnCellTypes, Boolean enterDataAtRollUps, SupplementalDataProviderInterface universalDataProviderInterface)
at Com.Sas.Ses.OfficeIntegration.Model.BaseQuery.execute
(ServerProviderInterface serverProvider, Cube cube, SingleDimAxis[]
SDAsInput, SingleDimAxis[]& SDAs, String& diagnosticsString, String&
diagnosticsODCSQueryHistoryString, OverrideProviderInterface opi, Boolean returnCellTypes, Boolean
enterDataAtRollUps, SupplementalDataProviderInterface universalDataProviderInterface)
This is a client-side error, and the server logs do not reveal this error.
This is marked as fixed in SAS Financial Management 5.3.
For information about enabling the AMO log, please refer to SAS Note 19846.
For default SAS Financial Management log locations, please refer to SAS Note 20058.
Operating System and Release Information
| Product Family | Product | System | Product Release | SAS Release | ||
| Reported | Fixed* | Reported | Fixed* | |||
| SAS System | SAS Financial Management | Microsoft® Windows® for x64 | 5.1 | 5.3 | 9.2 TS2M0 | 9.3 TS1M0 |
| Microsoft Windows Server 2003 Datacenter Edition | 5.1 | 5.3 | 9.2 TS2M0 | 9.3 TS1M0 | ||
| Microsoft Windows Server 2003 Enterprise Edition | 5.1 | 5.3 | 9.2 TS2M0 | 9.3 TS1M0 | ||
| Microsoft Windows Server 2003 Standard Edition | 5.1 | 5.3 | 9.2 TS2M0 | 9.3 TS1M0 | ||
| Microsoft Windows Server 2003 for x64 | 5.1 | 5.3 | 9.2 TS2M0 | 9.3 TS1M0 | ||
| Microsoft Windows Server 2008 for x64 | 5.1 | 5.3 | 9.2 TS2M0 | 9.3 TS1M0 | ||
| Microsoft Windows XP Professional | 5.1 | 5.3 | 9.2 TS2M0 | 9.3 TS1M0 | ||
| Windows Vista | 5.1 | 5.3 | 9.2 TS2M0 | 9.3 TS1M0 | ||
| Windows Vista for x64 | 5.1 | 5.3 | 9.2 TS2M0 | 9.3 TS1M0 | ||